<?php
$sql['get_pengumuman']="
  SELECT 
  	pengId AS PENG_ID,
  	pengJudul AS PENG_JUDUL,
  	pengTanggal AS PENG_TANGGAL
  FROM u_pengumunan
   WHERE pengDsn='%s'
   order by pengTanggal;
";

$sql['get_pengumuman_by_id']="
  SELECT 
  	pengId AS PENG_ID,
  	pengJudul AS PENG_JUDUL,
  	pengDsn AS PENG_DOSEN,
  	pengTanggal AS PENG_TANGGAL,
  	pengIsi AS PENG_ISI
  FROM u_pengumunan
   WHERE pengId='%s';
";
$sql['get_pengumuman_by_mhs_id']="
  SELECT 	
    pengId AS PENG_ID,
    pengJudul AS PENG_JUDUL,
    pengDsn AS PENG_DOSEN,
    pengTanggal AS PENG_TANGGAL,
    pengIsi AS PENG_ISI
  FROM u_pengumunan
  JOIN r_dosen_bimbingan ON dsnbimDsnId=pengDsn
  WHERE dsnbimMhsId='%s'
";
$sql['do_add_pengumuman']="
  INSERT u_pengumunan 
  SET 
    pengJudul='%s',
    pengDsn='%s',
    pengTanggal=NOW(),
    pengIsi='%s';
";

$sql['do_update_pengumunan']="
  UPDATE u_pengumunan
  SET 
    pengJudul='%s',
    pengDsn='%s',
    pengTanggal=NOW(),
    pengIsi='%s'
  WHERE pengId='%s';
";
?>
